package com.ruoyi.accountant.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class TransactionDetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TransactionDetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andTidIsNull() {
            addCriterion("tid is null");
            return (Criteria) this;
        }

        public Criteria andTidIsNotNull() {
            addCriterion("tid is not null");
            return (Criteria) this;
        }

        public Criteria andTidEqualTo(Long value) {
            addCriterion("tid =", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotEqualTo(Long value) {
            addCriterion("tid <>", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidGreaterThan(Long value) {
            addCriterion("tid >", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidGreaterThanOrEqualTo(Long value) {
            addCriterion("tid >=", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidLessThan(Long value) {
            addCriterion("tid <", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidLessThanOrEqualTo(Long value) {
            addCriterion("tid <=", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidIn(List<Long> values) {
            addCriterion("tid in", values, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotIn(List<Long> values) {
            addCriterion("tid not in", values, "tid");
            return (Criteria) this;
        }

        public Criteria andTidBetween(Long value1, Long value2) {
            addCriterion("tid between", value1, value2, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotBetween(Long value1, Long value2) {
            addCriterion("tid not between", value1, value2, "tid");
            return (Criteria) this;
        }

        public Criteria andDtypeIsNull() {
            addCriterion("dtype is null");
            return (Criteria) this;
        }

        public Criteria andDtypeIsNotNull() {
            addCriterion("dtype is not null");
            return (Criteria) this;
        }

        public Criteria andDtypeEqualTo(String value) {
            addCriterion("dtype =", value, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeNotEqualTo(String value) {
            addCriterion("dtype <>", value, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeGreaterThan(String value) {
            addCriterion("dtype >", value, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeGreaterThanOrEqualTo(String value) {
            addCriterion("dtype >=", value, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeLessThan(String value) {
            addCriterion("dtype <", value, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeLessThanOrEqualTo(String value) {
            addCriterion("dtype <=", value, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeLike(String value) {
            addCriterion("dtype like", value, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeNotLike(String value) {
            addCriterion("dtype not like", value, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeIn(List<String> values) {
            addCriterion("dtype in", values, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeNotIn(List<String> values) {
            addCriterion("dtype not in", values, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeBetween(String value1, String value2) {
            addCriterion("dtype between", value1, value2, "dtype");
            return (Criteria) this;
        }

        public Criteria andDtypeNotBetween(String value1, String value2) {
            addCriterion("dtype not between", value1, value2, "dtype");
            return (Criteria) this;
        }

        public Criteria andTransactionDateIsNull() {
            addCriterion("transaction_date is null");
            return (Criteria) this;
        }

        public Criteria andTransactionDateIsNotNull() {
            addCriterion("transaction_date is not null");
            return (Criteria) this;
        }

        public Criteria andTransactionDateEqualTo(Date value) {
            addCriterionForJDBCDate("transaction_date =", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("transaction_date <>", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateGreaterThan(Date value) {
            addCriterionForJDBCDate("transaction_date >", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("transaction_date >=", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateLessThan(Date value) {
            addCriterionForJDBCDate("transaction_date <", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("transaction_date <=", value, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateIn(List<Date> values) {
            addCriterionForJDBCDate("transaction_date in", values, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("transaction_date not in", values, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("transaction_date between", value1, value2, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andTransactionDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("transaction_date not between", value1, value2, "transactionDate");
            return (Criteria) this;
        }

        public Criteria andProofDateIsNull() {
            addCriterion("proof_date is null");
            return (Criteria) this;
        }

        public Criteria andProofDateIsNotNull() {
            addCriterion("proof_date is not null");
            return (Criteria) this;
        }

        public Criteria andProofDateEqualTo(Date value) {
            addCriterionForJDBCDate("proof_date =", value, "proofDate");
            return (Criteria) this;
        }

        public Criteria andProofDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("proof_date <>", value, "proofDate");
            return (Criteria) this;
        }

        public Criteria andProofDateGreaterThan(Date value) {
            addCriterionForJDBCDate("proof_date >", value, "proofDate");
            return (Criteria) this;
        }

        public Criteria andProofDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("proof_date >=", value, "proofDate");
            return (Criteria) this;
        }

        public Criteria andProofDateLessThan(Date value) {
            addCriterionForJDBCDate("proof_date <", value, "proofDate");
            return (Criteria) this;
        }

        public Criteria andProofDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("proof_date <=", value, "proofDate");
            return (Criteria) this;
        }

        public Criteria andProofDateIn(List<Date> values) {
            addCriterionForJDBCDate("proof_date in", values, "proofDate");
            return (Criteria) this;
        }

        public Criteria andProofDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("proof_date not in", values, "proofDate");
            return (Criteria) this;
        }

        public Criteria andProofDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("proof_date between", value1, value2, "proofDate");
            return (Criteria) this;
        }

        public Criteria andProofDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("proof_date not between", value1, value2, "proofDate");
            return (Criteria) this;
        }

        public Criteria andOfReasonIsNull() {
            addCriterion("of_reason is null");
            return (Criteria) this;
        }

        public Criteria andOfReasonIsNotNull() {
            addCriterion("of_reason is not null");
            return (Criteria) this;
        }

        public Criteria andOfReasonEqualTo(Long value) {
            addCriterion("of_reason =", value, "ofReason");
            return (Criteria) this;
        }

        public Criteria andOfReasonNotEqualTo(Long value) {
            addCriterion("of_reason <>", value, "ofReason");
            return (Criteria) this;
        }

        public Criteria andOfReasonGreaterThan(Long value) {
            addCriterion("of_reason >", value, "ofReason");
            return (Criteria) this;
        }

        public Criteria andOfReasonGreaterThanOrEqualTo(Long value) {
            addCriterion("of_reason >=", value, "ofReason");
            return (Criteria) this;
        }

        public Criteria andOfReasonLessThan(Long value) {
            addCriterion("of_reason <", value, "ofReason");
            return (Criteria) this;
        }

        public Criteria andOfReasonLessThanOrEqualTo(Long value) {
            addCriterion("of_reason <=", value, "ofReason");
            return (Criteria) this;
        }

        public Criteria andOfReasonIn(List<Long> values) {
            addCriterion("of_reason in", values, "ofReason");
            return (Criteria) this;
        }

        public Criteria andOfReasonNotIn(List<Long> values) {
            addCriterion("of_reason not in", values, "ofReason");
            return (Criteria) this;
        }

        public Criteria andOfReasonBetween(Long value1, Long value2) {
            addCriterion("of_reason between", value1, value2, "ofReason");
            return (Criteria) this;
        }

        public Criteria andOfReasonNotBetween(Long value1, Long value2) {
            addCriterion("of_reason not between", value1, value2, "ofReason");
            return (Criteria) this;
        }

        public Criteria andMoneyIsNull() {
            addCriterion("money is null");
            return (Criteria) this;
        }

        public Criteria andMoneyIsNotNull() {
            addCriterion("money is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyEqualTo(BigDecimal value) {
            addCriterion("money =", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotEqualTo(BigDecimal value) {
            addCriterion("money <>", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyGreaterThan(BigDecimal value) {
            addCriterion("money >", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("money >=", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyLessThan(BigDecimal value) {
            addCriterion("money <", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("money <=", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyIn(List<BigDecimal> values) {
            addCriterion("money in", values, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotIn(List<BigDecimal> values) {
            addCriterion("money not in", values, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("money between", value1, value2, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("money not between", value1, value2, "money");
            return (Criteria) this;
        }

        public Criteria andOfAccountIsNull() {
            addCriterion("of_account is null");
            return (Criteria) this;
        }

        public Criteria andOfAccountIsNotNull() {
            addCriterion("of_account is not null");
            return (Criteria) this;
        }

        public Criteria andOfAccountEqualTo(Long value) {
            addCriterion("of_account =", value, "ofAccount");
            return (Criteria) this;
        }

        public Criteria andOfAccountNotEqualTo(Long value) {
            addCriterion("of_account <>", value, "ofAccount");
            return (Criteria) this;
        }

        public Criteria andOfAccountGreaterThan(Long value) {
            addCriterion("of_account >", value, "ofAccount");
            return (Criteria) this;
        }

        public Criteria andOfAccountGreaterThanOrEqualTo(Long value) {
            addCriterion("of_account >=", value, "ofAccount");
            return (Criteria) this;
        }

        public Criteria andOfAccountLessThan(Long value) {
            addCriterion("of_account <", value, "ofAccount");
            return (Criteria) this;
        }

        public Criteria andOfAccountLessThanOrEqualTo(Long value) {
            addCriterion("of_account <=", value, "ofAccount");
            return (Criteria) this;
        }

        public Criteria andOfAccountIn(List<Long> values) {
            addCriterion("of_account in", values, "ofAccount");
            return (Criteria) this;
        }

        public Criteria andOfAccountNotIn(List<Long> values) {
            addCriterion("of_account not in", values, "ofAccount");
            return (Criteria) this;
        }

        public Criteria andOfAccountBetween(Long value1, Long value2) {
            addCriterion("of_account between", value1, value2, "ofAccount");
            return (Criteria) this;
        }

        public Criteria andOfAccountNotBetween(Long value1, Long value2) {
            addCriterion("of_account not between", value1, value2, "ofAccount");
            return (Criteria) this;
        }

        public Criteria andPredictDateIsNull() {
            addCriterion("predict_date is null");
            return (Criteria) this;
        }

        public Criteria andPredictDateIsNotNull() {
            addCriterion("predict_date is not null");
            return (Criteria) this;
        }

        public Criteria andPredictDateEqualTo(Date value) {
            addCriterionForJDBCDate("predict_date =", value, "predictDate");
            return (Criteria) this;
        }

        public Criteria andPredictDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("predict_date <>", value, "predictDate");
            return (Criteria) this;
        }

        public Criteria andPredictDateGreaterThan(Date value) {
            addCriterionForJDBCDate("predict_date >", value, "predictDate");
            return (Criteria) this;
        }

        public Criteria andPredictDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("predict_date >=", value, "predictDate");
            return (Criteria) this;
        }

        public Criteria andPredictDateLessThan(Date value) {
            addCriterionForJDBCDate("predict_date <", value, "predictDate");
            return (Criteria) this;
        }

        public Criteria andPredictDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("predict_date <=", value, "predictDate");
            return (Criteria) this;
        }

        public Criteria andPredictDateIn(List<Date> values) {
            addCriterionForJDBCDate("predict_date in", values, "predictDate");
            return (Criteria) this;
        }

        public Criteria andPredictDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("predict_date not in", values, "predictDate");
            return (Criteria) this;
        }

        public Criteria andPredictDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("predict_date between", value1, value2, "predictDate");
            return (Criteria) this;
        }

        public Criteria andPredictDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("predict_date not between", value1, value2, "predictDate");
            return (Criteria) this;
        }

        public Criteria andObjectIsNull() {
            addCriterion("object is null");
            return (Criteria) this;
        }

        public Criteria andObjectIsNotNull() {
            addCriterion("object is not null");
            return (Criteria) this;
        }

        public Criteria andObjectEqualTo(String value) {
            addCriterion("object =", value, "object");
            return (Criteria) this;
        }

        public Criteria andObjectNotEqualTo(String value) {
            addCriterion("object <>", value, "object");
            return (Criteria) this;
        }

        public Criteria andObjectGreaterThan(String value) {
            addCriterion("object >", value, "object");
            return (Criteria) this;
        }

        public Criteria andObjectGreaterThanOrEqualTo(String value) {
            addCriterion("object >=", value, "object");
            return (Criteria) this;
        }

        public Criteria andObjectLessThan(String value) {
            addCriterion("object <", value, "object");
            return (Criteria) this;
        }

        public Criteria andObjectLessThanOrEqualTo(String value) {
            addCriterion("object <=", value, "object");
            return (Criteria) this;
        }

        public Criteria andObjectLike(String value) {
            addCriterion("object like", value, "object");
            return (Criteria) this;
        }

        public Criteria andObjectNotLike(String value) {
            addCriterion("object not like", value, "object");
            return (Criteria) this;
        }

        public Criteria andObjectIn(List<String> values) {
            addCriterion("object in", values, "object");
            return (Criteria) this;
        }

        public Criteria andObjectNotIn(List<String> values) {
            addCriterion("object not in", values, "object");
            return (Criteria) this;
        }

        public Criteria andObjectBetween(String value1, String value2) {
            addCriterion("object between", value1, value2, "object");
            return (Criteria) this;
        }

        public Criteria andObjectNotBetween(String value1, String value2) {
            addCriterion("object not between", value1, value2, "object");
            return (Criteria) this;
        }

        public Criteria andCommentIsNull() {
            addCriterion("comment is null");
            return (Criteria) this;
        }

        public Criteria andCommentIsNotNull() {
            addCriterion("comment is not null");
            return (Criteria) this;
        }

        public Criteria andCommentEqualTo(String value) {
            addCriterion("comment =", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotEqualTo(String value) {
            addCriterion("comment <>", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThan(String value) {
            addCriterion("comment >", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThanOrEqualTo(String value) {
            addCriterion("comment >=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThan(String value) {
            addCriterion("comment <", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThanOrEqualTo(String value) {
            addCriterion("comment <=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLike(String value) {
            addCriterion("comment like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotLike(String value) {
            addCriterion("comment not like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentIn(List<String> values) {
            addCriterion("comment in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotIn(List<String> values) {
            addCriterion("comment not in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentBetween(String value1, String value2) {
            addCriterion("comment between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotBetween(String value1, String value2) {
            addCriterion("comment not between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andTagIsNull() {
            addCriterion("tag is null");
            return (Criteria) this;
        }

        public Criteria andTagIsNotNull() {
            addCriterion("tag is not null");
            return (Criteria) this;
        }

        public Criteria andTagEqualTo(String value) {
            addCriterion("tag =", value, "tag");
            return (Criteria) this;
        }

        public Criteria andTagNotEqualTo(String value) {
            addCriterion("tag <>", value, "tag");
            return (Criteria) this;
        }

        public Criteria andTagGreaterThan(String value) {
            addCriterion("tag >", value, "tag");
            return (Criteria) this;
        }

        public Criteria andTagGreaterThanOrEqualTo(String value) {
            addCriterion("tag >=", value, "tag");
            return (Criteria) this;
        }

        public Criteria andTagLessThan(String value) {
            addCriterion("tag <", value, "tag");
            return (Criteria) this;
        }

        public Criteria andTagLessThanOrEqualTo(String value) {
            addCriterion("tag <=", value, "tag");
            return (Criteria) this;
        }

        public Criteria andTagLike(String value) {
            addCriterion("tag like", value, "tag");
            return (Criteria) this;
        }

        public Criteria andTagNotLike(String value) {
            addCriterion("tag not like", value, "tag");
            return (Criteria) this;
        }

        public Criteria andTagIn(List<String> values) {
            addCriterion("tag in", values, "tag");
            return (Criteria) this;
        }

        public Criteria andTagNotIn(List<String> values) {
            addCriterion("tag not in", values, "tag");
            return (Criteria) this;
        }

        public Criteria andTagBetween(String value1, String value2) {
            addCriterion("tag between", value1, value2, "tag");
            return (Criteria) this;
        }

        public Criteria andTagNotBetween(String value1, String value2) {
            addCriterion("tag not between", value1, value2, "tag");
            return (Criteria) this;
        }

        public Criteria andTaxIsNull() {
            addCriterion("tax is null");
            return (Criteria) this;
        }

        public Criteria andTaxIsNotNull() {
            addCriterion("tax is not null");
            return (Criteria) this;
        }

        public Criteria andTaxEqualTo(BigDecimal value) {
            addCriterion("tax =", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotEqualTo(BigDecimal value) {
            addCriterion("tax <>", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThan(BigDecimal value) {
            addCriterion("tax >", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("tax >=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThan(BigDecimal value) {
            addCriterion("tax <", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("tax <=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxIn(List<BigDecimal> values) {
            addCriterion("tax in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotIn(List<BigDecimal> values) {
            addCriterion("tax not in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tax between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tax not between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andInvoiceIsNull() {
            addCriterion("invoice is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceIsNotNull() {
            addCriterion("invoice is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceEqualTo(String value) {
            addCriterion("invoice =", value, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceNotEqualTo(String value) {
            addCriterion("invoice <>", value, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceGreaterThan(String value) {
            addCriterion("invoice >", value, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceGreaterThanOrEqualTo(String value) {
            addCriterion("invoice >=", value, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceLessThan(String value) {
            addCriterion("invoice <", value, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceLessThanOrEqualTo(String value) {
            addCriterion("invoice <=", value, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceLike(String value) {
            addCriterion("invoice like", value, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceNotLike(String value) {
            addCriterion("invoice not like", value, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceIn(List<String> values) {
            addCriterion("invoice in", values, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceNotIn(List<String> values) {
            addCriterion("invoice not in", values, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceBetween(String value1, String value2) {
            addCriterion("invoice between", value1, value2, "invoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceNotBetween(String value1, String value2) {
            addCriterion("invoice not between", value1, value2, "invoice");
            return (Criteria) this;
        }

        public Criteria andAttachmentIsNull() {
            addCriterion("attachment is null");
            return (Criteria) this;
        }

        public Criteria andAttachmentIsNotNull() {
            addCriterion("attachment is not null");
            return (Criteria) this;
        }

        public Criteria andAttachmentEqualTo(String value) {
            addCriterion("attachment =", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotEqualTo(String value) {
            addCriterion("attachment <>", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentGreaterThan(String value) {
            addCriterion("attachment >", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentGreaterThanOrEqualTo(String value) {
            addCriterion("attachment >=", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentLessThan(String value) {
            addCriterion("attachment <", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentLessThanOrEqualTo(String value) {
            addCriterion("attachment <=", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentLike(String value) {
            addCriterion("attachment like", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotLike(String value) {
            addCriterion("attachment not like", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentIn(List<String> values) {
            addCriterion("attachment in", values, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotIn(List<String> values) {
            addCriterion("attachment not in", values, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentBetween(String value1, String value2) {
            addCriterion("attachment between", value1, value2, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotBetween(String value1, String value2) {
            addCriterion("attachment not between", value1, value2, "attachment");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Integer value) {
            addCriterion("deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Integer value) {
            addCriterion("deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Integer value) {
            addCriterion("deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Integer value) {
            addCriterion("deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Integer value) {
            addCriterion("deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Integer> values) {
            addCriterion("deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Integer> values) {
            addCriterion("deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Integer value1, Integer value2) {
            addCriterion("deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andOfDeviceIsNull() {
            addCriterion("of_device is null");
            return (Criteria) this;
        }

        public Criteria andOfDeviceIsNotNull() {
            addCriterion("of_device is not null");
            return (Criteria) this;
        }

        public Criteria andOfDeviceEqualTo(Long value) {
            addCriterion("of_device =", value, "ofDevice");
            return (Criteria) this;
        }

        public Criteria andOfDeviceNotEqualTo(Long value) {
            addCriterion("of_device <>", value, "ofDevice");
            return (Criteria) this;
        }

        public Criteria andOfDeviceGreaterThan(Long value) {
            addCriterion("of_device >", value, "ofDevice");
            return (Criteria) this;
        }

        public Criteria andOfDeviceGreaterThanOrEqualTo(Long value) {
            addCriterion("of_device >=", value, "ofDevice");
            return (Criteria) this;
        }

        public Criteria andOfDeviceLessThan(Long value) {
            addCriterion("of_device <", value, "ofDevice");
            return (Criteria) this;
        }

        public Criteria andOfDeviceLessThanOrEqualTo(Long value) {
            addCriterion("of_device <=", value, "ofDevice");
            return (Criteria) this;
        }

        public Criteria andOfDeviceIn(List<Long> values) {
            addCriterion("of_device in", values, "ofDevice");
            return (Criteria) this;
        }

        public Criteria andOfDeviceNotIn(List<Long> values) {
            addCriterion("of_device not in", values, "ofDevice");
            return (Criteria) this;
        }

        public Criteria andOfDeviceBetween(Long value1, Long value2) {
            addCriterion("of_device between", value1, value2, "ofDevice");
            return (Criteria) this;
        }

        public Criteria andOfDeviceNotBetween(Long value1, Long value2) {
            addCriterion("of_device not between", value1, value2, "ofDevice");
            return (Criteria) this;
        }

        public Criteria andInAccountIsNull() {
            addCriterion("in_account is null");
            return (Criteria) this;
        }

        public Criteria andInAccountIsNotNull() {
            addCriterion("in_account is not null");
            return (Criteria) this;
        }

        public Criteria andInAccountEqualTo(Long value) {
            addCriterion("in_account =", value, "inAccount");
            return (Criteria) this;
        }

        public Criteria andInAccountNotEqualTo(Long value) {
            addCriterion("in_account <>", value, "inAccount");
            return (Criteria) this;
        }

        public Criteria andInAccountGreaterThan(Long value) {
            addCriterion("in_account >", value, "inAccount");
            return (Criteria) this;
        }

        public Criteria andInAccountGreaterThanOrEqualTo(Long value) {
            addCriterion("in_account >=", value, "inAccount");
            return (Criteria) this;
        }

        public Criteria andInAccountLessThan(Long value) {
            addCriterion("in_account <", value, "inAccount");
            return (Criteria) this;
        }

        public Criteria andInAccountLessThanOrEqualTo(Long value) {
            addCriterion("in_account <=", value, "inAccount");
            return (Criteria) this;
        }

        public Criteria andInAccountIn(List<Long> values) {
            addCriterion("in_account in", values, "inAccount");
            return (Criteria) this;
        }

        public Criteria andInAccountNotIn(List<Long> values) {
            addCriterion("in_account not in", values, "inAccount");
            return (Criteria) this;
        }

        public Criteria andInAccountBetween(Long value1, Long value2) {
            addCriterion("in_account between", value1, value2, "inAccount");
            return (Criteria) this;
        }

        public Criteria andInAccountNotBetween(Long value1, Long value2) {
            addCriterion("in_account not between", value1, value2, "inAccount");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createtime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createtime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createtime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createtime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createtime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createtime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createtime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createtime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createtime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createtime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createtime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createtime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyIsNull() {
            addCriterion("of_currency is null");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyIsNotNull() {
            addCriterion("of_currency is not null");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyEqualTo(Integer value) {
            addCriterion("of_currency =", value, "ofCurrency");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyNotEqualTo(Integer value) {
            addCriterion("of_currency <>", value, "ofCurrency");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyGreaterThan(Integer value) {
            addCriterion("of_currency >", value, "ofCurrency");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyGreaterThanOrEqualTo(Integer value) {
            addCriterion("of_currency >=", value, "ofCurrency");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyLessThan(Integer value) {
            addCriterion("of_currency <", value, "ofCurrency");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyLessThanOrEqualTo(Integer value) {
            addCriterion("of_currency <=", value, "ofCurrency");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyIn(List<Integer> values) {
            addCriterion("of_currency in", values, "ofCurrency");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyNotIn(List<Integer> values) {
            addCriterion("of_currency not in", values, "ofCurrency");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyBetween(Integer value1, Integer value2) {
            addCriterion("of_currency between", value1, value2, "ofCurrency");
            return (Criteria) this;
        }

        public Criteria andOfCurrencyNotBetween(Integer value1, Integer value2) {
            addCriterion("of_currency not between", value1, value2, "ofCurrency");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdIsNull() {
            addCriterion("account_detail_id is null");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdIsNotNull() {
            addCriterion("account_detail_id is not null");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdEqualTo(Long value) {
            addCriterion("account_detail_id =", value, "accountDetailId");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdNotEqualTo(Long value) {
            addCriterion("account_detail_id <>", value, "accountDetailId");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdGreaterThan(Long value) {
            addCriterion("account_detail_id >", value, "accountDetailId");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdGreaterThanOrEqualTo(Long value) {
            addCriterion("account_detail_id >=", value, "accountDetailId");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdLessThan(Long value) {
            addCriterion("account_detail_id <", value, "accountDetailId");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdLessThanOrEqualTo(Long value) {
            addCriterion("account_detail_id <=", value, "accountDetailId");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdIn(List<Long> values) {
            addCriterion("account_detail_id in", values, "accountDetailId");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdNotIn(List<Long> values) {
            addCriterion("account_detail_id not in", values, "accountDetailId");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdBetween(Long value1, Long value2) {
            addCriterion("account_detail_id between", value1, value2, "accountDetailId");
            return (Criteria) this;
        }

        public Criteria andAccountDetailIdNotBetween(Long value1, Long value2) {
            addCriterion("account_detail_id not between", value1, value2, "accountDetailId");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdIsNull() {
            addCriterion("reason_detail_id is null");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdIsNotNull() {
            addCriterion("reason_detail_id is not null");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdEqualTo(Long value) {
            addCriterion("reason_detail_id =", value, "reasonDetailId");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdNotEqualTo(Long value) {
            addCriterion("reason_detail_id <>", value, "reasonDetailId");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdGreaterThan(Long value) {
            addCriterion("reason_detail_id >", value, "reasonDetailId");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdGreaterThanOrEqualTo(Long value) {
            addCriterion("reason_detail_id >=", value, "reasonDetailId");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdLessThan(Long value) {
            addCriterion("reason_detail_id <", value, "reasonDetailId");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdLessThanOrEqualTo(Long value) {
            addCriterion("reason_detail_id <=", value, "reasonDetailId");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdIn(List<Long> values) {
            addCriterion("reason_detail_id in", values, "reasonDetailId");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdNotIn(List<Long> values) {
            addCriterion("reason_detail_id not in", values, "reasonDetailId");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdBetween(Long value1, Long value2) {
            addCriterion("reason_detail_id between", value1, value2, "reasonDetailId");
            return (Criteria) this;
        }

        public Criteria andReasonDetailIdNotBetween(Long value1, Long value2) {
            addCriterion("reason_detail_id not between", value1, value2, "reasonDetailId");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyIsNull() {
            addCriterion("main_currency_money is null");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyIsNotNull() {
            addCriterion("main_currency_money is not null");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyEqualTo(BigDecimal value) {
            addCriterion("main_currency_money =", value, "mainCurrencyMoney");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyNotEqualTo(BigDecimal value) {
            addCriterion("main_currency_money <>", value, "mainCurrencyMoney");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyGreaterThan(BigDecimal value) {
            addCriterion("main_currency_money >", value, "mainCurrencyMoney");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("main_currency_money >=", value, "mainCurrencyMoney");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyLessThan(BigDecimal value) {
            addCriterion("main_currency_money <", value, "mainCurrencyMoney");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("main_currency_money <=", value, "mainCurrencyMoney");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyIn(List<BigDecimal> values) {
            addCriterion("main_currency_money in", values, "mainCurrencyMoney");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyNotIn(List<BigDecimal> values) {
            addCriterion("main_currency_money not in", values, "mainCurrencyMoney");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("main_currency_money between", value1, value2, "mainCurrencyMoney");
            return (Criteria) this;
        }

        public Criteria andMainCurrencyMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("main_currency_money not between", value1, value2, "mainCurrencyMoney");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNull() {
            addCriterion("tax_rate is null");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNotNull() {
            addCriterion("tax_rate is not null");
            return (Criteria) this;
        }

        public Criteria andTaxRateEqualTo(Double value) {
            addCriterion("tax_rate =", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotEqualTo(Double value) {
            addCriterion("tax_rate <>", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThan(Double value) {
            addCriterion("tax_rate >", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThanOrEqualTo(Double value) {
            addCriterion("tax_rate >=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThan(Double value) {
            addCriterion("tax_rate <", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThanOrEqualTo(Double value) {
            addCriterion("tax_rate <=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateIn(List<Double> values) {
            addCriterion("tax_rate in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotIn(List<Double> values) {
            addCriterion("tax_rate not in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateBetween(Double value1, Double value2) {
            addCriterion("tax_rate between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotBetween(Double value1, Double value2) {
            addCriterion("tax_rate not between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andDeletedDateIsNull() {
            addCriterion("deleted_date is null");
            return (Criteria) this;
        }

        public Criteria andDeletedDateIsNotNull() {
            addCriterion("deleted_date is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedDateEqualTo(Date value) {
            addCriterionForJDBCDate("deleted_date =", value, "deletedDate");
            return (Criteria) this;
        }

        public Criteria andDeletedDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("deleted_date <>", value, "deletedDate");
            return (Criteria) this;
        }

        public Criteria andDeletedDateGreaterThan(Date value) {
            addCriterionForJDBCDate("deleted_date >", value, "deletedDate");
            return (Criteria) this;
        }

        public Criteria andDeletedDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("deleted_date >=", value, "deletedDate");
            return (Criteria) this;
        }

        public Criteria andDeletedDateLessThan(Date value) {
            addCriterionForJDBCDate("deleted_date <", value, "deletedDate");
            return (Criteria) this;
        }

        public Criteria andDeletedDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("deleted_date <=", value, "deletedDate");
            return (Criteria) this;
        }

        public Criteria andDeletedDateIn(List<Date> values) {
            addCriterionForJDBCDate("deleted_date in", values, "deletedDate");
            return (Criteria) this;
        }

        public Criteria andDeletedDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("deleted_date not in", values, "deletedDate");
            return (Criteria) this;
        }

        public Criteria andDeletedDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("deleted_date between", value1, value2, "deletedDate");
            return (Criteria) this;
        }

        public Criteria andDeletedDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("deleted_date not between", value1, value2, "deletedDate");
            return (Criteria) this;
        }

        public Criteria andServiceChargeIsNull() {
            addCriterion("service_charge is null");
            return (Criteria) this;
        }

        public Criteria andServiceChargeIsNotNull() {
            addCriterion("service_charge is not null");
            return (Criteria) this;
        }

        public Criteria andServiceChargeEqualTo(Double value) {
            addCriterion("service_charge =", value, "serviceCharge");
            return (Criteria) this;
        }

        public Criteria andServiceChargeNotEqualTo(Double value) {
            addCriterion("service_charge <>", value, "serviceCharge");
            return (Criteria) this;
        }

        public Criteria andServiceChargeGreaterThan(Double value) {
            addCriterion("service_charge >", value, "serviceCharge");
            return (Criteria) this;
        }

        public Criteria andServiceChargeGreaterThanOrEqualTo(Double value) {
            addCriterion("service_charge >=", value, "serviceCharge");
            return (Criteria) this;
        }

        public Criteria andServiceChargeLessThan(Double value) {
            addCriterion("service_charge <", value, "serviceCharge");
            return (Criteria) this;
        }

        public Criteria andServiceChargeLessThanOrEqualTo(Double value) {
            addCriterion("service_charge <=", value, "serviceCharge");
            return (Criteria) this;
        }

        public Criteria andServiceChargeIn(List<Double> values) {
            addCriterion("service_charge in", values, "serviceCharge");
            return (Criteria) this;
        }

        public Criteria andServiceChargeNotIn(List<Double> values) {
            addCriterion("service_charge not in", values, "serviceCharge");
            return (Criteria) this;
        }

        public Criteria andServiceChargeBetween(Double value1, Double value2) {
            addCriterion("service_charge between", value1, value2, "serviceCharge");
            return (Criteria) this;
        }

        public Criteria andServiceChargeNotBetween(Double value1, Double value2) {
            addCriterion("service_charge not between", value1, value2, "serviceCharge");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeIsNull() {
            addCriterion("tax_rate_type is null");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeIsNotNull() {
            addCriterion("tax_rate_type is not null");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeEqualTo(String value) {
            addCriterion("tax_rate_type =", value, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeNotEqualTo(String value) {
            addCriterion("tax_rate_type <>", value, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeGreaterThan(String value) {
            addCriterion("tax_rate_type >", value, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeGreaterThanOrEqualTo(String value) {
            addCriterion("tax_rate_type >=", value, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeLessThan(String value) {
            addCriterion("tax_rate_type <", value, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeLessThanOrEqualTo(String value) {
            addCriterion("tax_rate_type <=", value, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeLike(String value) {
            addCriterion("tax_rate_type like", value, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeNotLike(String value) {
            addCriterion("tax_rate_type not like", value, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeIn(List<String> values) {
            addCriterion("tax_rate_type in", values, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeNotIn(List<String> values) {
            addCriterion("tax_rate_type not in", values, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeBetween(String value1, String value2) {
            addCriterion("tax_rate_type between", value1, value2, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andTaxRateTypeNotBetween(String value1, String value2) {
            addCriterion("tax_rate_type not between", value1, value2, "taxRateType");
            return (Criteria) this;
        }

        public Criteria andInCurrencyIsNull() {
            addCriterion("in_currency is null");
            return (Criteria) this;
        }

        public Criteria andInCurrencyIsNotNull() {
            addCriterion("in_currency is not null");
            return (Criteria) this;
        }

        public Criteria andInCurrencyEqualTo(Integer value) {
            addCriterion("in_currency =", value, "inCurrency");
            return (Criteria) this;
        }

        public Criteria andInCurrencyNotEqualTo(Integer value) {
            addCriterion("in_currency <>", value, "inCurrency");
            return (Criteria) this;
        }

        public Criteria andInCurrencyGreaterThan(Integer value) {
            addCriterion("in_currency >", value, "inCurrency");
            return (Criteria) this;
        }

        public Criteria andInCurrencyGreaterThanOrEqualTo(Integer value) {
            addCriterion("in_currency >=", value, "inCurrency");
            return (Criteria) this;
        }

        public Criteria andInCurrencyLessThan(Integer value) {
            addCriterion("in_currency <", value, "inCurrency");
            return (Criteria) this;
        }

        public Criteria andInCurrencyLessThanOrEqualTo(Integer value) {
            addCriterion("in_currency <=", value, "inCurrency");
            return (Criteria) this;
        }

        public Criteria andInCurrencyIn(List<Integer> values) {
            addCriterion("in_currency in", values, "inCurrency");
            return (Criteria) this;
        }

        public Criteria andInCurrencyNotIn(List<Integer> values) {
            addCriterion("in_currency not in", values, "inCurrency");
            return (Criteria) this;
        }

        public Criteria andInCurrencyBetween(Integer value1, Integer value2) {
            addCriterion("in_currency between", value1, value2, "inCurrency");
            return (Criteria) this;
        }

        public Criteria andInCurrencyNotBetween(Integer value1, Integer value2) {
            addCriterion("in_currency not between", value1, value2, "inCurrency");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeIsNull() {
            addCriterion("in_service_charge is null");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeIsNotNull() {
            addCriterion("in_service_charge is not null");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeEqualTo(Double value) {
            addCriterion("in_service_charge =", value, "inServiceCharge");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeNotEqualTo(Double value) {
            addCriterion("in_service_charge <>", value, "inServiceCharge");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeGreaterThan(Double value) {
            addCriterion("in_service_charge >", value, "inServiceCharge");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeGreaterThanOrEqualTo(Double value) {
            addCriterion("in_service_charge >=", value, "inServiceCharge");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeLessThan(Double value) {
            addCriterion("in_service_charge <", value, "inServiceCharge");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeLessThanOrEqualTo(Double value) {
            addCriterion("in_service_charge <=", value, "inServiceCharge");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeIn(List<Double> values) {
            addCriterion("in_service_charge in", values, "inServiceCharge");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeNotIn(List<Double> values) {
            addCriterion("in_service_charge not in", values, "inServiceCharge");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeBetween(Double value1, Double value2) {
            addCriterion("in_service_charge between", value1, value2, "inServiceCharge");
            return (Criteria) this;
        }

        public Criteria andInServiceChargeNotBetween(Double value1, Double value2) {
            addCriterion("in_service_charge not between", value1, value2, "inServiceCharge");
            return (Criteria) this;
        }

        public Criteria andIidIsNull() {
            addCriterion("iid is null");
            return (Criteria) this;
        }

        public Criteria andIidIsNotNull() {
            addCriterion("iid is not null");
            return (Criteria) this;
        }

        public Criteria andIidEqualTo(Long value) {
            addCriterion("iid =", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidNotEqualTo(Long value) {
            addCriterion("iid <>", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidGreaterThan(Long value) {
            addCriterion("iid >", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidGreaterThanOrEqualTo(Long value) {
            addCriterion("iid >=", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidLessThan(Long value) {
            addCriterion("iid <", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidLessThanOrEqualTo(Long value) {
            addCriterion("iid <=", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidIn(List<Long> values) {
            addCriterion("iid in", values, "iid");
            return (Criteria) this;
        }

        public Criteria andIidNotIn(List<Long> values) {
            addCriterion("iid not in", values, "iid");
            return (Criteria) this;
        }

        public Criteria andIidBetween(Long value1, Long value2) {
            addCriterion("iid between", value1, value2, "iid");
            return (Criteria) this;
        }

        public Criteria andIidNotBetween(Long value1, Long value2) {
            addCriterion("iid not between", value1, value2, "iid");
            return (Criteria) this;
        }

        public Criteria andFinishedIsNull() {
            addCriterion("finished is null");
            return (Criteria) this;
        }

        public Criteria andFinishedIsNotNull() {
            addCriterion("finished is not null");
            return (Criteria) this;
        }

        public Criteria andFinishedEqualTo(Integer value) {
            addCriterion("finished =", value, "finished");
            return (Criteria) this;
        }

        public Criteria andFinishedNotEqualTo(Integer value) {
            addCriterion("finished <>", value, "finished");
            return (Criteria) this;
        }

        public Criteria andFinishedGreaterThan(Integer value) {
            addCriterion("finished >", value, "finished");
            return (Criteria) this;
        }

        public Criteria andFinishedGreaterThanOrEqualTo(Integer value) {
            addCriterion("finished >=", value, "finished");
            return (Criteria) this;
        }

        public Criteria andFinishedLessThan(Integer value) {
            addCriterion("finished <", value, "finished");
            return (Criteria) this;
        }

        public Criteria andFinishedLessThanOrEqualTo(Integer value) {
            addCriterion("finished <=", value, "finished");
            return (Criteria) this;
        }

        public Criteria andFinishedIn(List<Integer> values) {
            addCriterion("finished in", values, "finished");
            return (Criteria) this;
        }

        public Criteria andFinishedNotIn(List<Integer> values) {
            addCriterion("finished not in", values, "finished");
            return (Criteria) this;
        }

        public Criteria andFinishedBetween(Integer value1, Integer value2) {
            addCriterion("finished between", value1, value2, "finished");
            return (Criteria) this;
        }

        public Criteria andFinishedNotBetween(Integer value1, Integer value2) {
            addCriterion("finished not between", value1, value2, "finished");
            return (Criteria) this;
        }

        public Criteria andWithDepositIsNull() {
            addCriterion("with_deposit is null");
            return (Criteria) this;
        }

        public Criteria andWithDepositIsNotNull() {
            addCriterion("with_deposit is not null");
            return (Criteria) this;
        }

        public Criteria andWithDepositEqualTo(Integer value) {
            addCriterion("with_deposit =", value, "withDeposit");
            return (Criteria) this;
        }

        public Criteria andWithDepositNotEqualTo(Integer value) {
            addCriterion("with_deposit <>", value, "withDeposit");
            return (Criteria) this;
        }

        public Criteria andWithDepositGreaterThan(Integer value) {
            addCriterion("with_deposit >", value, "withDeposit");
            return (Criteria) this;
        }

        public Criteria andWithDepositGreaterThanOrEqualTo(Integer value) {
            addCriterion("with_deposit >=", value, "withDeposit");
            return (Criteria) this;
        }

        public Criteria andWithDepositLessThan(Integer value) {
            addCriterion("with_deposit <", value, "withDeposit");
            return (Criteria) this;
        }

        public Criteria andWithDepositLessThanOrEqualTo(Integer value) {
            addCriterion("with_deposit <=", value, "withDeposit");
            return (Criteria) this;
        }

        public Criteria andWithDepositIn(List<Integer> values) {
            addCriterion("with_deposit in", values, "withDeposit");
            return (Criteria) this;
        }

        public Criteria andWithDepositNotIn(List<Integer> values) {
            addCriterion("with_deposit not in", values, "withDeposit");
            return (Criteria) this;
        }

        public Criteria andWithDepositBetween(Integer value1, Integer value2) {
            addCriterion("with_deposit between", value1, value2, "withDeposit");
            return (Criteria) this;
        }

        public Criteria andWithDepositNotBetween(Integer value1, Integer value2) {
            addCriterion("with_deposit not between", value1, value2, "withDeposit");
            return (Criteria) this;
        }

        public Criteria andDepositIdIsNull() {
            addCriterion("deposit_id is null");
            return (Criteria) this;
        }

        public Criteria andDepositIdIsNotNull() {
            addCriterion("deposit_id is not null");
            return (Criteria) this;
        }

        public Criteria andDepositIdEqualTo(Long value) {
            addCriterion("deposit_id =", value, "depositId");
            return (Criteria) this;
        }

        public Criteria andDepositIdNotEqualTo(Long value) {
            addCriterion("deposit_id <>", value, "depositId");
            return (Criteria) this;
        }

        public Criteria andDepositIdGreaterThan(Long value) {
            addCriterion("deposit_id >", value, "depositId");
            return (Criteria) this;
        }

        public Criteria andDepositIdGreaterThanOrEqualTo(Long value) {
            addCriterion("deposit_id >=", value, "depositId");
            return (Criteria) this;
        }

        public Criteria andDepositIdLessThan(Long value) {
            addCriterion("deposit_id <", value, "depositId");
            return (Criteria) this;
        }

        public Criteria andDepositIdLessThanOrEqualTo(Long value) {
            addCriterion("deposit_id <=", value, "depositId");
            return (Criteria) this;
        }

        public Criteria andDepositIdIn(List<Long> values) {
            addCriterion("deposit_id in", values, "depositId");
            return (Criteria) this;
        }

        public Criteria andDepositIdNotIn(List<Long> values) {
            addCriterion("deposit_id not in", values, "depositId");
            return (Criteria) this;
        }

        public Criteria andDepositIdBetween(Long value1, Long value2) {
            addCriterion("deposit_id between", value1, value2, "depositId");
            return (Criteria) this;
        }

        public Criteria andDepositIdNotBetween(Long value1, Long value2) {
            addCriterion("deposit_id not between", value1, value2, "depositId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}